St Peter’s Planner Generator

πŸ“˜ How to Use the Planner Generator

  1. Select the terms you want to print
  2. Set Extra Pages for lined, grid, or blank notes using the boxes below.
  3. Create a copy of the spreadsheet template and follow the instructions on it for how to prepare your timetable, duties, and events.
    πŸ“„ Open Planner Spreadsheet Template
  4. Once your spreadsheet is complete, export it as a .csv file.
    Then click πŸ“‚ Load Planner button below and select your exported CSV file.
    ⚠️ Ensure all data is correctly formatted before uploading.
  5. After loading, the planner will automatically generate all pages.
    ⚠️ This process takes around 15 seconds β€” please wait and don’t click again during this time.
  6. Once complete, you can:
    • πŸ–¨οΈ Export to PDF and then print your planner.
  7. Optionally, you can combine your planner PDF with other files such as class photos or cover pages.
    🧩 Open Adobe PDF Combiner

🎯 How to Add Deadlines

  1. Open the Deadlines Template spreadsheet:
    πŸ“„ Open Deadlines Template
  2. For each class, start a new section with a header row such as:
    Class: 13BIO (must match your timetable name)
  3. On the next line, write:
    Deadline: Assessment Name
    and list each deadline title across the row (e.g. Deadline 1, Deadline 2, Deadline 3).
  4. In the next line, enter the deadline dates below each Deadline heading using dd/mm/yyyy format.
  5. Below this, list student names (one per row). These names will appear on the printed Deadline tracking page.
  6. Repeat this pattern for each class section (Class β†’ Deadline β†’ Dates β†’ Students).
  7. If you just want a deadline but no list at the end of planner dont include any students.
  8. Export the completed sheet as a .csv file.
    In the planner, click 🎯 Load Deadline CSV and select your exported file.
    βœ… The deadlines will now appear in the timetable cells on their due dates.

Extra Pages

Page TypeNumber of Pages
Lined Pages (10 mm ruled)
Grid Pages (10 mm squares)
Blank Note Pages